const conn = require('../../libs/DB/Conn');
module.exports = async function (params) {
    let checkUserSql = `SELECT      
                          uf.user_id AS userId,
                          uf.user_name AS userName,
                          uf.login_name AS loginName,
                          uf.mobile
                        FROM
                          user_file uf 
                        INNER JOIN user_group ug ON uf.group_id = ug.group_id AND ug.group_id = 2  
                        INNER JOIN domain_file df ON df.domain_id = uf.domain_id AND df.delete_sign = 1 AND df.agent_id = ${params.userAgentId}            
                        WHERE  uf.delete_sign = 1 AND uf.domain_id = ${params.domainId}`;
    let dataList = await conn(checkUserSql);
    return {success: true ,dataList:dataList}
};